home *** CD-ROM | disk | FTP | other *** search
/ Developer Source 17 / Developer Source Volume 17 (I-MODE Publications, Inc.)(2000).iso / delph / 991 / woodf101.gif < prev    next >
Graphics Interchange Format  |  2000-01-03  |  55.5 KB  |  486x376  |  4-bit (16 colors)
   ocr: operation Purpose Situation TABLE ACCESS FULL Sequential full-toble: scans no WHERE: clauseisused: TABIE ACCESS BY ROWID etneve rows by internal row cccessing, through indexes Dvery.efficient) INDEX UNIQUE SCAN Reneve rows via o unique index. a unique andex can be: used for a WHERE clause. INDEX RANGE SCAN tetreves rows via on index. anon-unique index can be used, oro range ofuniquely'indexeds valuess required AND-EQUAL Combine mutiple index scons- accessing.via.indexes connected by AND. CONCATENATION Combine muitiple index scons. occessing via on. index on multiple values. SORT ORDER BY Sortr ...